Store Stock Redistribution supports different calculation types to identify the items that need to be redistributed to other stores.
The Manual Redistribution calculation type calculates the sales demand until the end of season, lifecycle, or calculation horizon for the items across stores and warehouses. Furthermore, the system calculates the current variant availability to identify broken variants. This calculation type does not classify locations into locations with demand or supply.
The Retail Item Variant Availability by Location page lets you determine manually how the variants shall be redistributed among the stores.
Calculation concept
This calculation type differentiates between two calculation approaches:
- Items without an assigned Lifecycle Curve
- Items with an assigned Lifecycle Curve.
Those approaches define how the expected sales quantity until the calculation horizon is calculated.
Items without an assigned Lifecycle Curve
For these items the calculation is based on the Average Sales Quantity from the calculation start date until today.
Calculation steps:
- Calculation of the Average Sales Quantity for each Item-Variant-Location combination for a defined time period (the Start Date in the Redistribution Replenishment Journal and the current date).
- Calculation of number of days until end of time period (End Date in Redistribution Replenishment Journal and current date).
- Calculation of Demand until End Date (Average Sales Quantity * Days until End Date).
- Calculation of Effective Inventory at End Date (current Effective Inventory minus Demand until End Date).
Items with an assigned Lifecycle Curve
For these items the calculation is based on the assigned Lifecycle Curve and the Lifecycle Starting Date.
The above chart shows an item's lifecycle. The lifecycle starts in week 4 (introduction of product) and ends in week 11. Our Redistribution Replenishment Journal was run with a Journal Start Date in week 5 and an Journal End Date in week 10. The current date is in week 7. The yellow area shows the (expected) sales behavior of the item during its lifecycle - there is a slow start with an increase until week 7. Later, the sales will slowly decrease and finally, in week 10 and 11, drop significantly.
In the calculation the sold quantity is calculated within the calculation horizon (Journal Start Date until Journal End Date). The lifecycle is applied to understand, in which phase of the lifecycle the item is and what can be expect to be sold until the end of the calculation horizon (Journal End Date).
Calculation steps:
- Calculation of sold quantity between Journal Start Date and current date (area B in the chart).
In the example: 50 pcs. - Calculation of the percentage share of the area B of the total Lifecycle.
In other words: the sum of the percentage shares of areas A+B+C+D is 100 %. What is the percentage share of B? - Calculation of the percentage share of the area C of the total Lifecycle.
This area represents the time from the current day until the end of the calculation horizon. This is the time that is still left to sell the item. - Calculation of Demand until End Date.
Formula: sold quantity (area B) divided by percentage share of area B multiplied by percentage share of area C.
This is the quantity that is expected to be sold until the Journal End Date, based on the lifecycle and sold quantity until today.
Click here for information on how to set up Lifecycle Curves.
Setup fields on Redist. Template
| Field | Description |
|---|---|
| Replenishment Type | Here you can select whether the Replenishment Template is to be used for creating Purchase Orders or Transfer Orders. The selection Redistribution is used for Store Stock Redistribution. |
| Redistribution Calculation Type | Defines the type, how the system calculates the Redist. Stock and Redist. Demand. The available values are:
|
| Redistribution Strategy | Defines the strategy, how the system calculates the trips between stores with Redist. Stock and Redist. Demand. The available values are:
More information can be found here: Redist. Strategies. |
| Redistribution Warehouse Stock | This field is used for Store Stock Redistribution and defines how available stock in the Warehouse is treated. The available values are:
More information can be found here: Warehouse in Redistribution. |
| Linked Lifecycle Planning Worksheet | Defines the Lifecycle Planning Worksheet name that is linked to this template. The items to be calculated in the journal will be taken from the Linked Lifecycle Planning Worksheet. This field is assigned from Lifecycle Worksheets which can be accessed via the Name lookup in Lifecycle Planning Worksheet.
More information can be found here: Lifecycle Planning Worksheet. |
| Season Code | Defines the Season Code that will be used to filter the items considered in the calculation. |
| Start Date | Defines the start date to be used for Store Stock Redistribution calculation. This is the starting date to be based on when calculating sales information such as Qty. Sold until Today, Sell Through % and Average Daily Sales. It is automatically assigned with the season's starting date if a Season Code is selected. |
| End Date | Defines the end date to be used for store stock redistribution calculation, this is the ending date to be based on when calculating sales information such as Demand until End Date. It is automatically assigned with the season's ending date if a Season Code is selected. |
| Stockout % Above | Stockout % defines the ratio of out-of-stock item variants to the total number of item variants from all stores. Only items with Stockout % above the value defined in this field will be considered in the calculation. |
| Sell Through % Above | Sell Through % defines the ratio of total sold inventory of the item as of today to its total inventory as of start date. Only items with Sell Through % above the value defined in this field will be considered in the calculation. |
Filters on Redist. Template
In the Redist. Template you can set the filters you want to apply to the items considered in the calculation.
| Filter | Description |
|---|---|
| Vendor No. Filter | Here you can enter a filter for the Vendor No. field of the items. An example is 1000 if you only want to select items from vendor number 1000. If you enter 1000..2000 the system will select all items from vendor number 1000 to 2000. |
| Item Division Code | A filter for the Division Code field of the item. |
| Item Category Filter | A filter for the Item Category Code field of the item. |
| Item Product Group Filter | A filter for the Product Group Code field of the item. |
| Item No. Filter | A filter for the item number. |
| Special Group Code Filter | A filter for Special Groups. Only items in these Special Groups will be considered in the calculation. |
| Item Attribute Filter | A filter for Attributes. |
| From Location Filter
To Location Filter |
Filter for From Location and To Location. When Store Stock Redistribution calculates the inventory in the Locations, it classifies Locations into Supply Locations (=From Location Filter) and Demand Locations (=To Location Filter). When the Calculation Type Manual Redistribution is used, From Location Filter and To Location Filter always have the same value. This filter will set Locations to the status Excluded in Store Stock Redistribution when the Calculation TypeManual Redistribution is used. Locations that are filtered out will not appear in the Preview and Journal Lines. |
Calculation result
The calculation of Redist. Preview is initiated with the Add Items to Preview action on the Redistribution Replenishment Journal page.
When the preview is calculated, the Show Redist. Preview action opens the Redistribution Journal Preview page where you can view the calculated sales performance indicators (such as Sell Through %, Demand until End Date, etc) for the items across stores. The locations are not classified into locations with demand or supply, that is, the Redist. Stock and Redist. Demand are not automatically calculated by the system.
The system further calculates the current variant availability to identify broken variants. From the preview page, the Show Items Availability action, or a lookup on the Stockout% or Variant Availability % opens up the Retail Item Variant Availability by Location page, which enables you to manually determine how the variants shall be redistributed among the stores. For more information on how to manually assign Redist. Stock and Redist. Demand, please refer to Retail Item Variant Availability by Location.
Fields on Redistribution Journal Preview
| Field | Description |
|---|---|
| Item No. | Defines the Item Number. |
| Exclude | Items with this check box selected will be excluded from redistribution trips calculation. |
| Stockout % | Defines the ratio of out-of-stock item variants to the total number of item variants from all stores. |
| Sell Through % | Defines the ratio of total sold inventory of the item as of today to its total inventory as of start date. |
| Sell Through % (Expected) | Defines the expected Sell Through % based on the start date, current date, and end date, as well as the lifecycle curve, if assigned to the item. |
| Inventory | Defines the total inventory of the item. |
| Eff. Inventory | Defines the total inventory of the item, considering also the Purchase Orders, Sales Orders, and Transfer Orders that have not been posted. |
| Eff. Inventory at End Date | Defines the remaining effective inventory of the item on the end date. |
| Days until End Date | Defines how many days are remaining from the current date until the end date. |
| Average Daily Sales | Defines the calculated average daily sales of the item from the start date until the current date. |
| Redist. Stock | Defines the total redistributable quantity of the item across all stores. |
| Redist. Demand | This field defines the total demand quantity of the item across all stores. |
See Also
Redistribution Calculation Types